



using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace RingCast {
	
        /// <summary>
        /// Table: aspnet_Users
        /// Primary Key: UserId
        /// </summary>

        public class aspnet_UsersTable: DatabaseTable {
            
            public aspnet_UsersTable(IDataProvider provider):base("aspnet_Users",provider){
                ClassName = "aspnet_User";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ApplicationId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Guid,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("UserId", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Guid,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("UserName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 256
                });

                Columns.Add(new DatabaseColumn("LoweredUserName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 256
                });

                Columns.Add(new DatabaseColumn("MobileAlias", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 16
                });

                Columns.Add(new DatabaseColumn("IsAnonymous", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("LastActivityDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn ApplicationId{
                get{
                    return this.GetColumn("ApplicationId");
                }
            }
				
   			public static string ApplicationIdColumn{
			      get{
        			return "ApplicationId";
      			}
		    }
            
            public IColumn UserId{
                get{
                    return this.GetColumn("UserId");
                }
            }
				
   			public static string UserIdColumn{
			      get{
        			return "UserId";
      			}
		    }
            
            public IColumn UserName{
                get{
                    return this.GetColumn("UserName");
                }
            }
				
   			public static string UserNameColumn{
			      get{
        			return "UserName";
      			}
		    }
            
            public IColumn LoweredUserName{
                get{
                    return this.GetColumn("LoweredUserName");
                }
            }
				
   			public static string LoweredUserNameColumn{
			      get{
        			return "LoweredUserName";
      			}
		    }
            
            public IColumn MobileAlias{
                get{
                    return this.GetColumn("MobileAlias");
                }
            }
				
   			public static string MobileAliasColumn{
			      get{
        			return "MobileAlias";
      			}
		    }
            
            public IColumn IsAnonymous{
                get{
                    return this.GetColumn("IsAnonymous");
                }
            }
				
   			public static string IsAnonymousColumn{
			      get{
        			return "IsAnonymous";
      			}
		    }
            
            public IColumn LastActivityDate{
                get{
                    return this.GetColumn("LastActivityDate");
                }
            }
				
   			public static string LastActivityDateColumn{
			      get{
        			return "LastActivityDate";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Pipes
        /// Primary Key: Id
        /// </summary>

        public class PipesTable: DatabaseTable {
            
            public PipesTable(IDataProvider provider):base("Pipes",provider){
                ClassName = "Pipe";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Identifier", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Tariff", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Currency,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("InboundGatewayId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("OutboundGatewayId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("BillingTypeId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CountryId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("IsEnabled", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Identifier{
                get{
                    return this.GetColumn("Identifier");
                }
            }
				
   			public static string IdentifierColumn{
			      get{
        			return "Identifier";
      			}
		    }
            
            public IColumn Tariff{
                get{
                    return this.GetColumn("Tariff");
                }
            }
				
   			public static string TariffColumn{
			      get{
        			return "Tariff";
      			}
		    }
            
            public IColumn InboundGatewayId{
                get{
                    return this.GetColumn("InboundGatewayId");
                }
            }
				
   			public static string InboundGatewayIdColumn{
			      get{
        			return "InboundGatewayId";
      			}
		    }
            
            public IColumn OutboundGatewayId{
                get{
                    return this.GetColumn("OutboundGatewayId");
                }
            }
				
   			public static string OutboundGatewayIdColumn{
			      get{
        			return "OutboundGatewayId";
      			}
		    }
            
            public IColumn BillingTypeId{
                get{
                    return this.GetColumn("BillingTypeId");
                }
            }
				
   			public static string BillingTypeIdColumn{
			      get{
        			return "BillingTypeId";
      			}
		    }
            
            public IColumn CountryId{
                get{
                    return this.GetColumn("CountryId");
                }
            }
				
   			public static string CountryIdColumn{
			      get{
        			return "CountryId";
      			}
		    }
            
            public IColumn IsEnabled{
                get{
                    return this.GetColumn("IsEnabled");
                }
            }
				
   			public static string IsEnabledColumn{
			      get{
        			return "IsEnabled";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: MessageAttachments
        /// Primary Key: Id
        /// </summary>

        public class MessageAttachmentsTable: DatabaseTable {
            
            public MessageAttachmentsTable(IDataProvider provider):base("MessageAttachments",provider){
                ClassName = "MessageAttachment";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn MessageId{
                get{
                    return this.GetColumn("MessageId");
                }
            }
				
   			public static string MessageIdColumn{
			      get{
        			return "MessageId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: GatewayCredentials
        /// Primary Key: Id
        /// </summary>

        public class GatewayCredentialsTable: DatabaseTable {
            
            public GatewayCredentialsTable(IDataProvider provider):base("GatewayCredentials",provider){
                ClassName = "GatewayCredential";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("GatewayId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Key", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("DefaultValue", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn GatewayId{
                get{
                    return this.GetColumn("GatewayId");
                }
            }
				
   			public static string GatewayIdColumn{
			      get{
        			return "GatewayId";
      			}
		    }
            
            public IColumn Key{
                get{
                    return this.GetColumn("Key");
                }
            }
				
   			public static string KeyColumn{
			      get{
        			return "Key";
      			}
		    }
            
            public IColumn DefaultValue{
                get{
                    return this.GetColumn("DefaultValue");
                }
            }
				
   			public static string DefaultValueColumn{
			      get{
        			return "DefaultValue";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: ClientGatewayCredentials
        /// Primary Key: Id
        /// </summary>

        public class ClientGatewayCredentialsTable: DatabaseTable {
            
            public ClientGatewayCredentialsTable(IDataProvider provider):base("ClientGatewayCredentials",provider){
                ClassName = "ClientGatewayCredential";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ClientId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("GatewayCredentialId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Value", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn ClientId{
                get{
                    return this.GetColumn("ClientId");
                }
            }
				
   			public static string ClientIdColumn{
			      get{
        			return "ClientId";
      			}
		    }
            
            public IColumn GatewayCredentialId{
                get{
                    return this.GetColumn("GatewayCredentialId");
                }
            }
				
   			public static string GatewayCredentialIdColumn{
			      get{
        			return "GatewayCredentialId";
      			}
		    }
            
            public IColumn Value{
                get{
                    return this.GetColumn("Value");
                }
            }
				
   			public static string ValueColumn{
			      get{
        			return "Value";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: RequestLogTypes
        /// Primary Key: Id
        /// </summary>

        public class RequestLogTypesTable: DatabaseTable {
            
            public RequestLogTypesTable(IDataProvider provider):base("RequestLogTypes",provider){
                ClassName = "RequestLogType";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: RequestLog
        /// Primary Key: Id
        /// </summary>

        public class RequestLogTable: DatabaseTable {
            
            public RequestLogTable(IDataProvider provider):base("RequestLog",provider){
                ClassName = "RequestLog";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("URL", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });

                Columns.Add(new DatabaseColumn("Request", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });

                Columns.Add(new DatabaseColumn("IP", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CountryId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("RequestLogTypeId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn URL{
                get{
                    return this.GetColumn("URL");
                }
            }
				
   			public static string URLColumn{
			      get{
        			return "URL";
      			}
		    }
            
            public IColumn Request{
                get{
                    return this.GetColumn("Request");
                }
            }
				
   			public static string RequestColumn{
			      get{
        			return "Request";
      			}
		    }
            
            public IColumn IP{
                get{
                    return this.GetColumn("IP");
                }
            }
				
   			public static string IPColumn{
			      get{
        			return "IP";
      			}
		    }
            
            public IColumn CountryId{
                get{
                    return this.GetColumn("CountryId");
                }
            }
				
   			public static string CountryIdColumn{
			      get{
        			return "CountryId";
      			}
		    }
            
            public IColumn RequestLogTypeId{
                get{
                    return this.GetColumn("RequestLogTypeId");
                }
            }
				
   			public static string RequestLogTypeIdColumn{
			      get{
        			return "RequestLogTypeId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Sessions
        /// Primary Key: Id
        /// </summary>

        public class SessionsTable: DatabaseTable {
            
            public SessionsTable(IDataProvider provider):base("Sessions",provider){
                ClassName = "Session";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CampaignId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("IsClosed", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn CampaignId{
                get{
                    return this.GetColumn("CampaignId");
                }
            }
				
   			public static string CampaignIdColumn{
			      get{
        			return "CampaignId";
      			}
		    }
            
            public IColumn IsClosed{
                get{
                    return this.GetColumn("IsClosed");
                }
            }
				
   			public static string IsClosedColumn{
			      get{
        			return "IsClosed";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: PlatformSettings
        /// Primary Key: Id
        /// </summary>

        public class PlatformSettingsTable: DatabaseTable {
            
            public PlatformSettingsTable(IDataProvider provider):base("PlatformSettings",provider){
                ClassName = "PlatformSetting";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Key", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Value", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Key{
                get{
                    return this.GetColumn("Key");
                }
            }
				
   			public static string KeyColumn{
			      get{
        			return "Key";
      			}
		    }
            
            public IColumn Value{
                get{
                    return this.GetColumn("Value");
                }
            }
				
   			public static string ValueColumn{
			      get{
        			return "Value";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: GatewayIPs
        /// Primary Key: Id
        /// </summary>

        public class GatewayIPsTable: DatabaseTable {
            
            public GatewayIPsTable(IDataProvider provider):base("GatewayIPs",provider){
                ClassName = "GatewayIP";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("GatewayId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("IPAddress", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn GatewayId{
                get{
                    return this.GetColumn("GatewayId");
                }
            }
				
   			public static string GatewayIdColumn{
			      get{
        			return "GatewayId";
      			}
		    }
            
            public IColumn IPAddress{
                get{
                    return this.GetColumn("IPAddress");
                }
            }
				
   			public static string IPAddressColumn{
			      get{
        			return "IPAddress";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Shells
        /// Primary Key: Id
        /// </summary>

        public class ShellsTable: DatabaseTable {
            
            public ShellsTable(IDataProvider provider):base("Shells",provider){
                ClassName = "Shell";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("ProviderName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ProviderType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("IsEnabled", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn ProviderName{
                get{
                    return this.GetColumn("ProviderName");
                }
            }
				
   			public static string ProviderNameColumn{
			      get{
        			return "ProviderName";
      			}
		    }
            
            public IColumn ProviderType{
                get{
                    return this.GetColumn("ProviderType");
                }
            }
				
   			public static string ProviderTypeColumn{
			      get{
        			return "ProviderType";
      			}
		    }
            
            public IColumn IsEnabled{
                get{
                    return this.GetColumn("IsEnabled");
                }
            }
				
   			public static string IsEnabledColumn{
			      get{
        			return "IsEnabled";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: MessageTypes
        /// Primary Key: Id
        /// </summary>

        public class MessageTypesTable: DatabaseTable {
            
            public MessageTypesTable(IDataProvider provider):base("MessageTypes",provider){
                ClassName = "MessageType";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: ShellCredentials
        /// Primary Key: Id
        /// </summary>

        public class ShellCredentialsTable: DatabaseTable {
            
            public ShellCredentialsTable(IDataProvider provider):base("ShellCredentials",provider){
                ClassName = "ShellCredential";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ShellId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Key", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("DefaultValue", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn ShellId{
                get{
                    return this.GetColumn("ShellId");
                }
            }
				
   			public static string ShellIdColumn{
			      get{
        			return "ShellId";
      			}
		    }
            
            public IColumn Key{
                get{
                    return this.GetColumn("Key");
                }
            }
				
   			public static string KeyColumn{
			      get{
        			return "Key";
      			}
		    }
            
            public IColumn DefaultValue{
                get{
                    return this.GetColumn("DefaultValue");
                }
            }
				
   			public static string DefaultValueColumn{
			      get{
        			return "DefaultValue";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: MessageStatuses
        /// Primary Key: Id
        /// </summary>

        public class MessageStatusesTable: DatabaseTable {
            
            public MessageStatusesTable(IDataProvider provider):base("MessageStatuses",provider){
                ClassName = "MessageStatus";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Campaigns
        /// Primary Key: Id
        /// </summary>

        public class CampaignsTable: DatabaseTable {
            
            public CampaignsTable(IDataProvider provider):base("Campaigns",provider){
                ClassName = "Campaign";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ClientId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Description", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("StartDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("EndDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("AutoResponseMessage", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("IsEnabled", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn ClientId{
                get{
                    return this.GetColumn("ClientId");
                }
            }
				
   			public static string ClientIdColumn{
			      get{
        			return "ClientId";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn Description{
                get{
                    return this.GetColumn("Description");
                }
            }
				
   			public static string DescriptionColumn{
			      get{
        			return "Description";
      			}
		    }
            
            public IColumn StartDate{
                get{
                    return this.GetColumn("StartDate");
                }
            }
				
   			public static string StartDateColumn{
			      get{
        			return "StartDate";
      			}
		    }
            
            public IColumn EndDate{
                get{
                    return this.GetColumn("EndDate");
                }
            }
				
   			public static string EndDateColumn{
			      get{
        			return "EndDate";
      			}
		    }
            
            public IColumn AutoResponseMessage{
                get{
                    return this.GetColumn("AutoResponseMessage");
                }
            }
				
   			public static string AutoResponseMessageColumn{
			      get{
        			return "AutoResponseMessage";
      			}
		    }
            
            public IColumn IsEnabled{
                get{
                    return this.GetColumn("IsEnabled");
                }
            }
				
   			public static string IsEnabledColumn{
			      get{
        			return "IsEnabled";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Gateways
        /// Primary Key: Id
        /// </summary>

        public class GatewaysTable: DatabaseTable {
            
            public GatewaysTable(IDataProvider provider):base("Gateways",provider){
                ClassName = "Gateway";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("ProviderName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ProviderType", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("IsOutboundDefault", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("IsEnabled", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn ProviderName{
                get{
                    return this.GetColumn("ProviderName");
                }
            }
				
   			public static string ProviderNameColumn{
			      get{
        			return "ProviderName";
      			}
		    }
            
            public IColumn ProviderType{
                get{
                    return this.GetColumn("ProviderType");
                }
            }
				
   			public static string ProviderTypeColumn{
			      get{
        			return "ProviderType";
      			}
		    }
            
            public IColumn IsOutboundDefault{
                get{
                    return this.GetColumn("IsOutboundDefault");
                }
            }
				
   			public static string IsOutboundDefaultColumn{
			      get{
        			return "IsOutboundDefault";
      			}
		    }
            
            public IColumn IsEnabled{
                get{
                    return this.GetColumn("IsEnabled");
                }
            }
				
   			public static string IsEnabledColumn{
			      get{
        			return "IsEnabled";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: ClientShellCredentials
        /// Primary Key: Id
        /// </summary>

        public class ClientShellCredentialsTable: DatabaseTable {
            
            public ClientShellCredentialsTable(IDataProvider provider):base("ClientShellCredentials",provider){
                ClassName = "ClientShellCredential";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ClientId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ShellCredentialId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Value", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn ClientId{
                get{
                    return this.GetColumn("ClientId");
                }
            }
				
   			public static string ClientIdColumn{
			      get{
        			return "ClientId";
      			}
		    }
            
            public IColumn ShellCredentialId{
                get{
                    return this.GetColumn("ShellCredentialId");
                }
            }
				
   			public static string ShellCredentialIdColumn{
			      get{
        			return "ShellCredentialId";
      			}
		    }
            
            public IColumn Value{
                get{
                    return this.GetColumn("Value");
                }
            }
				
   			public static string ValueColumn{
			      get{
        			return "Value";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: MessageDirections
        /// Primary Key: Id
        /// </summary>

        public class MessageDirectionsTable: DatabaseTable {
            
            public MessageDirectionsTable(IDataProvider provider):base("MessageDirections",provider){
                ClassName = "MessageDirection";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: InterfaceResults
        /// Primary Key: Id
        /// </summary>

        public class InterfaceResultsTable: DatabaseTable {
            
            public InterfaceResultsTable(IDataProvider provider):base("InterfaceResults",provider){
                ClassName = "InterfaceResult";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ResultCode", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ResultMessage", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Created", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("LastModified", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn ResultCode{
                get{
                    return this.GetColumn("ResultCode");
                }
            }
				
   			public static string ResultCodeColumn{
			      get{
        			return "ResultCode";
      			}
		    }
            
            public IColumn ResultMessage{
                get{
                    return this.GetColumn("ResultMessage");
                }
            }
				
   			public static string ResultMessageColumn{
			      get{
        			return "ResultMessage";
      			}
		    }
            
            public IColumn Created{
                get{
                    return this.GetColumn("Created");
                }
            }
				
   			public static string CreatedColumn{
			      get{
        			return "Created";
      			}
		    }
            
            public IColumn LastModified{
                get{
                    return this.GetColumn("LastModified");
                }
            }
				
   			public static string LastModifiedColumn{
			      get{
        			return "LastModified";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: CampaignShells
        /// Primary Key: Id
        /// </summary>

        public class CampaignShellsTable: DatabaseTable {
            
            public CampaignShellsTable(IDataProvider provider):base("CampaignShells",provider){
                ClassName = "CampaignShell";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CampaignId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ShellId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("StartDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("EndDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn CampaignId{
                get{
                    return this.GetColumn("CampaignId");
                }
            }
				
   			public static string CampaignIdColumn{
			      get{
        			return "CampaignId";
      			}
		    }
            
            public IColumn ShellId{
                get{
                    return this.GetColumn("ShellId");
                }
            }
				
   			public static string ShellIdColumn{
			      get{
        			return "ShellId";
      			}
		    }
            
            public IColumn StartDate{
                get{
                    return this.GetColumn("StartDate");
                }
            }
				
   			public static string StartDateColumn{
			      get{
        			return "StartDate";
      			}
		    }
            
            public IColumn EndDate{
                get{
                    return this.GetColumn("EndDate");
                }
            }
				
   			public static string EndDateColumn{
			      get{
        			return "EndDate";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Messages
        /// Primary Key: Id
        /// </summary>

        public class MessagesTable: DatabaseTable {
            
            public MessagesTable(IDataProvider provider):base("Messages",provider){
                ClassName = "Message";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SessionId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SequenceNumber", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ClientReference", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Body", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2047
                });

                Columns.Add(new DatabaseColumn("MessageTypeId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageDirectionId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageStatusId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("GatewayId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CustomerId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("PipeId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("SenderName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("RequestLogId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn SessionId{
                get{
                    return this.GetColumn("SessionId");
                }
            }
				
   			public static string SessionIdColumn{
			      get{
        			return "SessionId";
      			}
		    }
            
            public IColumn SequenceNumber{
                get{
                    return this.GetColumn("SequenceNumber");
                }
            }
				
   			public static string SequenceNumberColumn{
			      get{
        			return "SequenceNumber";
      			}
		    }
            
            public IColumn ClientReference{
                get{
                    return this.GetColumn("ClientReference");
                }
            }
				
   			public static string ClientReferenceColumn{
			      get{
        			return "ClientReference";
      			}
		    }
            
            public IColumn Body{
                get{
                    return this.GetColumn("Body");
                }
            }
				
   			public static string BodyColumn{
			      get{
        			return "Body";
      			}
		    }
            
            public IColumn MessageTypeId{
                get{
                    return this.GetColumn("MessageTypeId");
                }
            }
				
   			public static string MessageTypeIdColumn{
			      get{
        			return "MessageTypeId";
      			}
		    }
            
            public IColumn MessageDirectionId{
                get{
                    return this.GetColumn("MessageDirectionId");
                }
            }
				
   			public static string MessageDirectionIdColumn{
			      get{
        			return "MessageDirectionId";
      			}
		    }
            
            public IColumn MessageStatusId{
                get{
                    return this.GetColumn("MessageStatusId");
                }
            }
				
   			public static string MessageStatusIdColumn{
			      get{
        			return "MessageStatusId";
      			}
		    }
            
            public IColumn GatewayId{
                get{
                    return this.GetColumn("GatewayId");
                }
            }
				
   			public static string GatewayIdColumn{
			      get{
        			return "GatewayId";
      			}
		    }
            
            public IColumn CustomerId{
                get{
                    return this.GetColumn("CustomerId");
                }
            }
				
   			public static string CustomerIdColumn{
			      get{
        			return "CustomerId";
      			}
		    }
            
            public IColumn PipeId{
                get{
                    return this.GetColumn("PipeId");
                }
            }
				
   			public static string PipeIdColumn{
			      get{
        			return "PipeId";
      			}
		    }
            
            public IColumn SenderName{
                get{
                    return this.GetColumn("SenderName");
                }
            }
				
   			public static string SenderNameColumn{
			      get{
        			return "SenderName";
      			}
		    }
            
            public IColumn RequestLogId{
                get{
                    return this.GetColumn("RequestLogId");
                }
            }
				
   			public static string RequestLogIdColumn{
			      get{
        			return "RequestLogId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Countries
        /// Primary Key: Id
        /// </summary>

        public class CountriesTable: DatabaseTable {
            
            public CountriesTable(IDataProvider provider):base("Countries",provider){
                ClassName = "Country";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Code", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiStringFixedLength,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2
                });

                Columns.Add(new DatabaseColumn("Prefix", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MCC", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Currency", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("CurrencySymbol", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn Code{
                get{
                    return this.GetColumn("Code");
                }
            }
				
   			public static string CodeColumn{
			      get{
        			return "Code";
      			}
		    }
            
            public IColumn Prefix{
                get{
                    return this.GetColumn("Prefix");
                }
            }
				
   			public static string PrefixColumn{
			      get{
        			return "Prefix";
      			}
		    }
            
            public IColumn MCC{
                get{
                    return this.GetColumn("MCC");
                }
            }
				
   			public static string MCCColumn{
			      get{
        			return "MCC";
      			}
		    }
            
            public IColumn Currency{
                get{
                    return this.GetColumn("Currency");
                }
            }
				
   			public static string CurrencyColumn{
			      get{
        			return "Currency";
      			}
		    }
            
            public IColumn CurrencySymbol{
                get{
                    return this.GetColumn("CurrencySymbol");
                }
            }
				
   			public static string CurrencySymbolColumn{
			      get{
        			return "CurrencySymbol";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: PipeMappings
        /// Primary Key: Id
        /// </summary>

        public class PipeMappingsTable: DatabaseTable {
            
            public PipeMappingsTable(IDataProvider provider):base("PipeMappings",provider){
                ClassName = "PipeMapping";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("PipeId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Identifier", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("NetworkOperatorId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("BindIdentifier", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn PipeId{
                get{
                    return this.GetColumn("PipeId");
                }
            }
				
   			public static string PipeIdColumn{
			      get{
        			return "PipeId";
      			}
		    }
            
            public IColumn Identifier{
                get{
                    return this.GetColumn("Identifier");
                }
            }
				
   			public static string IdentifierColumn{
			      get{
        			return "Identifier";
      			}
		    }
            
            public IColumn NetworkOperatorId{
                get{
                    return this.GetColumn("NetworkOperatorId");
                }
            }
				
   			public static string NetworkOperatorIdColumn{
			      get{
        			return "NetworkOperatorId";
      			}
		    }
            
            public IColumn BindIdentifier{
                get{
                    return this.GetColumn("BindIdentifier");
                }
            }
				
   			public static string BindIdentifierColumn{
			      get{
        			return "BindIdentifier";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: OutboundGatewayCountries
        /// Primary Key: Id
        /// </summary>

        public class OutboundGatewayCountriesTable: DatabaseTable {
            
            public OutboundGatewayCountriesTable(IDataProvider provider):base("OutboundGatewayCountries",provider){
                ClassName = "OutboundGatewayCountry";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CountryId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("GatewayId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn CountryId{
                get{
                    return this.GetColumn("CountryId");
                }
            }
				
   			public static string CountryIdColumn{
			      get{
        			return "CountryId";
      			}
		    }
            
            public IColumn GatewayId{
                get{
                    return this.GetColumn("GatewayId");
                }
            }
				
   			public static string GatewayIdColumn{
			      get{
        			return "GatewayId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: InboundMessageQueue
        /// Primary Key: Id
        /// </summary>

        public class InboundMessageQueueTable: DatabaseTable {
            
            public InboundMessageQueueTable(IDataProvider provider):base("InboundMessageQueue",provider){
                ClassName = "InboundMessageQueue";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn MessageId{
                get{
                    return this.GetColumn("MessageId");
                }
            }
				
   			public static string MessageIdColumn{
			      get{
        			return "MessageId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: NetworkOperators
        /// Primary Key: Id
        /// </summary>

        public class NetworkOperatorsTable: DatabaseTable {
            
            public NetworkOperatorsTable(IDataProvider provider):base("NetworkOperators",provider){
                ClassName = "NetworkOperator";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("MNC", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CountryId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn MNC{
                get{
                    return this.GetColumn("MNC");
                }
            }
				
   			public static string MNCColumn{
			      get{
        			return "MNC";
      			}
		    }
            
            public IColumn CountryId{
                get{
                    return this.GetColumn("CountryId");
                }
            }
				
   			public static string CountryIdColumn{
			      get{
        			return "CountryId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: OutboundMessageQueue
        /// Primary Key: Id
        /// </summary>

        public class OutboundMessageQueueTable: DatabaseTable {
            
            public OutboundMessageQueueTable(IDataProvider provider):base("OutboundMessageQueue",provider){
                ClassName = "OutboundMessageQueue";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn MessageId{
                get{
                    return this.GetColumn("MessageId");
                }
            }
				
   			public static string MessageIdColumn{
			      get{
        			return "MessageId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Customers
        /// Primary Key: Id
        /// </summary>

        public class CustomersTable: DatabaseTable {
            
            public CustomersTable(IDataProvider provider):base("Customers",provider){
                ClassName = "Customer";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Identifier", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("NetworkOperatorId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Identifier{
                get{
                    return this.GetColumn("Identifier");
                }
            }
				
   			public static string IdentifierColumn{
			      get{
        			return "Identifier";
      			}
		    }
            
            public IColumn NetworkOperatorId{
                get{
                    return this.GetColumn("NetworkOperatorId");
                }
            }
				
   			public static string NetworkOperatorIdColumn{
			      get{
        			return "NetworkOperatorId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: ClientUsers
        /// Primary Key: Id
        /// </summary>

        public class ClientUsersTable: DatabaseTable {
            
            public ClientUsersTable(IDataProvider provider):base("ClientUsers",provider){
                ClassName = "ClientUser";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ClientId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("aspnet_UserId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Guid,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Position", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn ClientId{
                get{
                    return this.GetColumn("ClientId");
                }
            }
				
   			public static string ClientIdColumn{
			      get{
        			return "ClientId";
      			}
		    }
            
            public IColumn aspnet_UserId{
                get{
                    return this.GetColumn("aspnet_UserId");
                }
            }
				
   			public static string aspnet_UserIdColumn{
			      get{
        			return "aspnet_UserId";
      			}
		    }
            
            public IColumn Position{
                get{
                    return this.GetColumn("Position");
                }
            }
				
   			public static string PositionColumn{
			      get{
        			return "Position";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: MessageHistory
        /// Primary Key: Id
        /// </summary>

        public class MessageHistoryTable: DatabaseTable {
            
            public MessageHistoryTable(IDataProvider provider):base("MessageHistory",provider){
                ClassName = "MessageHistory";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageStatusId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Details", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1024
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn MessageId{
                get{
                    return this.GetColumn("MessageId");
                }
            }
				
   			public static string MessageIdColumn{
			      get{
        			return "MessageId";
      			}
		    }
            
            public IColumn MessageStatusId{
                get{
                    return this.GetColumn("MessageStatusId");
                }
            }
				
   			public static string MessageStatusIdColumn{
			      get{
        			return "MessageStatusId";
      			}
		    }
            
            public IColumn Details{
                get{
                    return this.GetColumn("Details");
                }
            }
				
   			public static string DetailsColumn{
			      get{
        			return "Details";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: ClientStatuses
        /// Primary Key: Id
        /// </summary>

        public class ClientStatusesTable: DatabaseTable {
            
            public ClientStatusesTable(IDataProvider provider):base("ClientStatuses",provider){
                ClassName = "ClientStatus";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: OutboundBatch
        /// Primary Key: Id
        /// </summary>

        public class OutboundBatchTable: DatabaseTable {
            
            public OutboundBatchTable(IDataProvider provider):base("OutboundBatch",provider){
                ClassName = "OutboundBatch";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Clients
        /// Primary Key: Id
        /// </summary>

        public class ClientsTable: DatabaseTable {
            
            public ClientsTable(IDataProvider provider):base("Clients",provider){
                ClassName = "Client";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Login", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("Password", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("ClientStatusId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn Login{
                get{
                    return this.GetColumn("Login");
                }
            }
				
   			public static string LoginColumn{
			      get{
        			return "Login";
      			}
		    }
            
            public IColumn Password{
                get{
                    return this.GetColumn("Password");
                }
            }
				
   			public static string PasswordColumn{
			      get{
        			return "Password";
      			}
		    }
            
            public IColumn ClientStatusId{
                get{
                    return this.GetColumn("ClientStatusId");
                }
            }
				
   			public static string ClientStatusIdColumn{
			      get{
        			return "ClientStatusId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: PipeCampaignKeywords
        /// Primary Key: Id
        /// </summary>

        public class PipeCampaignKeywordsTable: DatabaseTable {
            
            public PipeCampaignKeywordsTable(IDataProvider provider):base("PipeCampaignKeywords",provider){
                ClassName = "PipeCampaignKeyword";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("PipeId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CampaignId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Keyword", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn PipeId{
                get{
                    return this.GetColumn("PipeId");
                }
            }
				
   			public static string PipeIdColumn{
			      get{
        			return "PipeId";
      			}
		    }
            
            public IColumn CampaignId{
                get{
                    return this.GetColumn("CampaignId");
                }
            }
				
   			public static string CampaignIdColumn{
			      get{
        			return "CampaignId";
      			}
		    }
            
            public IColumn Keyword{
                get{
                    return this.GetColumn("Keyword");
                }
            }
				
   			public static string KeywordColumn{
			      get{
        			return "Keyword";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: BillingTypes
        /// Primary Key: Id
        /// </summary>

        public class BillingTypesTable: DatabaseTable {
            
            public BillingTypesTable(IDataProvider provider):base("BillingTypes",provider){
                ClassName = "BillingType";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: CampaignIdentifierPool
        /// Primary Key: Id
        /// </summary>

        public class CampaignIdentifierPoolTable: DatabaseTable {
            
            public CampaignIdentifierPoolTable(IDataProvider provider):base("CampaignIdentifierPool",provider){
                ClassName = "CampaignIdentifierPool";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CampaignId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Identifier", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn CampaignId{
                get{
                    return this.GetColumn("CampaignId");
                }
            }
				
   			public static string CampaignIdColumn{
			      get{
        			return "CampaignId";
      			}
		    }
            
            public IColumn Identifier{
                get{
                    return this.GetColumn("Identifier");
                }
            }
				
   			public static string IdentifierColumn{
			      get{
        			return "Identifier";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: OutboundBatchMessages
        /// Primary Key: Id
        /// </summary>

        public class OutboundBatchMessagesTable: DatabaseTable {
            
            public OutboundBatchMessagesTable(IDataProvider provider):base("OutboundBatchMessages",provider){
                ClassName = "OutboundBatchMessage";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("OutboundBatchId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MessageId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = true,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("CreatedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("ModifiedOn", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ModifiedBy", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("IsDeleted", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Boolean,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }
            
            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn OutboundBatchId{
                get{
                    return this.GetColumn("OutboundBatchId");
                }
            }
				
   			public static string OutboundBatchIdColumn{
			      get{
        			return "OutboundBatchId";
      			}
		    }
            
            public IColumn MessageId{
                get{
                    return this.GetColumn("MessageId");
                }
            }
				
   			public static string MessageIdColumn{
			      get{
        			return "MessageId";
      			}
		    }
            
            public IColumn CreatedOn{
                get{
                    return this.GetColumn("CreatedOn");
                }
            }
				
   			public static string CreatedOnColumn{
			      get{
        			return "CreatedOn";
      			}
		    }
            
            public IColumn CreatedBy{
                get{
                    return this.GetColumn("CreatedBy");
                }
            }
				
   			public static string CreatedByColumn{
			      get{
        			return "CreatedBy";
      			}
		    }
            
            public IColumn ModifiedOn{
                get{
                    return this.GetColumn("ModifiedOn");
                }
            }
				
   			public static string ModifiedOnColumn{
			      get{
        			return "ModifiedOn";
      			}
		    }
            
            public IColumn ModifiedBy{
                get{
                    return this.GetColumn("ModifiedBy");
                }
            }
				
   			public static string ModifiedByColumn{
			      get{
        			return "ModifiedBy";
      			}
		    }
            
            public IColumn IsDeleted{
                get{
                    return this.GetColumn("IsDeleted");
                }
            }
				
   			public static string IsDeletedColumn{
			      get{
        			return "IsDeleted";
      			}
		    }
            
                    
        }
        
}